<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <meta name="description" content="Fashi Template">
    <meta name="keywords" content="Fashi, unica, creative, html">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
	<title>${ user.user_name }的收藏夹</title>
	<link rel="icon" href="img/title.ico" type="image/x-icon">
    <!-- Google Font -->
    <link href="https://fonts.googleapis.com/css?family=Muli:300,400,500,600,700,800,900&display=swap" rel="stylesheet">

    <!-- Css Styles -->
    <link rel="stylesheet" href="css/bootstrap.min.css" type="text/css">
    <link rel="stylesheet" href="css/font-awesome.min.css" type="text/css">
    <link rel="stylesheet" href="css/themify-icons.css" type="text/css">
    <link rel="stylesheet" href="css/elegant-icons.css" type="text/css">
    <link rel="stylesheet" href="css/owl.carousel.min.css" type="text/css">
    <link rel="stylesheet" href="css/nice-select.css" type="text/css">
    <link rel="stylesheet" href="css/jquery-ui.min.css" type="text/css">
    <link rel="stylesheet" href="css/slicknav.min.css" type="text/css">
    <link rel="stylesheet" href="css/style.css" type="text/css">
    <style type="text/css">
    a{
    	text-decoration: none;
    }
    </style>
    <style>
        .videoimg{
            width: 100%;
            margin-left: 30px;
        }
    </style>
</head>
<body>
    <!-- Page Preloder -->
    <div id="preloder">
        <div class="loader"></div>
    </div>
    
    <sql:setDataSource var="snapshot" driver="com.mysql.cj.jdbc.Driver"
	url="jdbc:mysql://localhost:3306/${ SqlName }?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC"
	user="${ SqlUser }"  password="${ SqlPass }"/>

    <!-- Header Section Begin -->
    <header class="header-section" style="position: fixed;top: 0;z-index: 99;width: 100%;">
        <div class="nav-item" style="position: relative;">
            <div class="container">
                <div class="nav-depart" style="position: fixed;left: 0;">
                    <div class="depart-btn">
                        <i class="ti-menu"></i>
                        <span><span style="color: #8fb0db;">Blue</span> VIDEO</span>
                        <ul class="depart-hover">
                            <li><a href="BlueVideoColle">我的收藏</a></li>
                            <li><a href="#">展览演出</a></li>
                            <li><a href="#">历史记录</a></li>
                        </ul>
                    </div>
                </div>
                <nav class="nav-menu mobile-menu">
                    <ul style="margin-left: 291px;">
                        <li><a href="BlueVideo">首页</a></li>
                        <li><a href="BlueVideoRec" style="border: none;">推荐</a></li>
                        <li>
                            <form action="SelectVideo" method="get">
                                <input class="primary-btn" type="text" id="username" name="selectvideo" style="margin-left:10px;background-color: #fff;color: black;border: none;">
                                <input class="primary-btn" type="submit" value="搜索" style="margin-right: 10px;margin-left: -4px;margin-top: 5px;border: none;">
                            </form>
                        </li>
                    </ul>
                    <ul style="position: fixed;right: -20px;">
                        <c:if test="${ user.user_name==null }">
                        	<li style="position: relative;"><a href="#" style="width: 100%;display: block;">
                            未登录
	                        </a>
	                        	<ul class="dropdown">
	                                <li><a href="BlueVideoLogin">去登录</a></li>
	                                <li><a href="BlueVideoReg">去注册</a></li>
	                            </ul>
	                        </li>
                        </c:if>
                        <c:if test="${ user.user_name!=null }">
                        <li>
                        	<a href="BlueVideoAdd">创作视频</a>
                        </li>
                        	<li style="position: relative;"><a href="#" style="width: 100%;display: block;">
                            <img src="img/UserImg/${ user.user_img }" style="position: absolute;top: 0;left: -20%;width: 38%;border-radius:100%;">
                            ${ user.user_name }
                            </a>
	                            <ul class="dropdown">
	                                <li><a href="BlueVideoUserIndex">个人信息</a></li>
	                                
	                                <li style="position: relative;">
	                                <a href="BlueVideoUserMsg">信息</a>
	                                <sql:query dataSource="${snapshot}" var="resultusermsgsum">
									SELECT COUNT(msg_log) AS usermsgsum FROM user_msg WHERE user_id = ${ user.user_id } AND msg_log = 1;
									</sql:query>
									
									<c:forEach var="rowusermsgsum" items="${ resultusermsgsum.rows }">
									<c:if test="${ rowusermsgsum.usermsgsum > 0 }">
									<div style="position: absolute;left:65px;top: 12px;background: red;border-radius: 50%;color: #fff;">
	                                	<div style="width: 25px;text-align:center;">${ rowusermsgsum.usermsgsum }</div>
	                                </div>
									</c:if>
	                                </c:forEach>
	                                </li>
	                                
	                                <li><a href="BlueVideoSeeUser?SeeUserid=${ user.user_id }">动态</a></li>
	                                <li><a href="BlueVideoUserMyVideo">我的视频</a></li>
	                                <li><a href="BlueVideoUserOut" style="color: #aaa000">退出登录</a></li>
	                            </ul>
	                        </li>
                        </c:if>
                    </ul>
                </nav>
                <div id="mobile-menu-wrap"></div>
            </div>
        </div>
    </header>
    <!-- Header End -->
	
	<sql:query dataSource="${snapshot}" var="result">
		SELECT video_table.* FROM video_table,video_colle WHERE video_colle.user_id = ${ user.user_id } AND video_table.videoid = video_colle.videoid AND videoaudit = 0 AND video_table.videoname like "%${ videoname }%"
	</sql:query>

    <!-- Shopping Cart Section Begin -->
    <section class="shopping-cart spad">
        <div class="container">
            <div class="row">
                <div class="col-lg-12">
                    <div class="cart-table">
                        <table>
                            <thead>
                                <tr style="position: relative;">
                                    <th><a style="color: #000;" href="">默认收藏夹</a></th>
                                    <th class="p-name"></th>
                                    <th>
                            		</th>
                            		<th>
                            		</th>
                                </tr>
                            </thead>
                            <tbody>
                            	
                            	<tr>
                            		<td></td>
                            		<td>
                            		<form action=" " method="post" style="margin-top: 10px;">
                                	<input class="primary-btn" type="text" id="videonames" name="selectvideo" value="${ videoname }" style="margin-left:10px;background-color: #f4f4f7;color: black;border: none;">
                                	<input class="primary-btn" type="submit" value="搜索" style="margin-right: 10px;margin-left: -6px;margin-top: 5px;border: none;background: #babaf5">
                           	 		</form>
                           	 		</td>
                            	</tr>
                            	
								<c:forEach var="row" items="${ result.rows }">
                                <tr>
                                    <td class="cart-pic first-row"><a href="BlueVideoPlay?VideoID=${ row.videoid }"><img class="videoimg" src="Video/${ row.videoimg }" alt=""></a></td>
                                    <td class="">
                                        <h5>UID:${ row.videoid }</h5>
                                    </td>
                                    <td class="">
                                        <h5>${ row.videoname }</h5>
                                    </td>
                                    <td class="close-td first-row">
                                        <a href="RemoveVideo?videoid=${ row.videoid }&userid=${ user.user_id }" style="color: #ee4747;">
                                            <i class="ti-close"></i>
                                        </a>
                                    </td>
                                </tr>
								</c:forEach>
								
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </section>
    <!-- Shopping Cart Section End -->

    <!-- Js Plugins -->
    <script src="js/jquery-3.3.1.min.js"></script>
    <script src="js/bootstrap.min.js"></script>
    <script src="js/jquery-ui.min.js"></script>
    <script src="js/jquery.countdown.min.js"></script>
    <script src="js/jquery.nice-select.min.js"></script>
    <script src="js/jquery.zoom.min.js"></script>
    <script src="js/jquery.dd.min.js"></script>
    <script src="js/jquery.slicknav.js"></script>
    <script src="js/owl.carousel.min.js"></script>
    <script src="js/main.js"></script>
</body>
</html>